<cfif IsUserInRole("Super User") or IsUserInRole("Regional Admin")>
	<cfinclude template="#request.pathToUI#/grids/scholarships.cfm" />
<cfelse>
	<div class="row">
		<div class="banner prepare-banner">
			<div class="banner-text">
				<span class="banner-header">Announce Scholarships</span><br />
				<!--- <span class="banner-subheader">Lorem ipsum dolor sequitir</span> --->
			</div>
		</div>
	</div>
	<div class="row body-row">
		<div class="span3">
			<ul class="nav nav-tabs nav-stacked sidenav">
				<li><a href="#overview">Overview</a></li>
				<li><a href="#scholarship-materials">Scholarship Materials</a></li>
				<li><a href="#scholarships">Scholarship Recipients</a></li>
				<li><a href="#whats-next">What&rsquo;s Next</a></li>
			</ul>
		</div>
		<div class="span9 content">
		
			<section id="overview">
				<h3>Overview</h3>
				<!--- <p>After each workshop season exit survey data is matched to the CSAC Grant Delivery System (GDS).  GDS data reveals if a workshop participant has successfuly submitted a FAFSA or Dream Act Application and whether their GPA transcript has been received by CSAC. Both are eligibility requirements for a Cash for College scholarship and scholarships cannot be awarded until matching is complete.  Data matching and scholarship selection are typically completed in mid to late-May after which recipients are listed here for you to award.</p>
				<p>We give you the opportunity to award scholarships because we have received feedback that it is a pleasant and rewarding experience.</p>
				<p>The Materials section of this page includes templates used to award scholarships and inform recipients of the things they must do to receive payment. They're important. Please contact us if you have any questions or need assistance awarding your scholarships.</p> --->
				<h4>What&lsquo;s Different This Year</h4>
				<h5>Scholarships are regional</h5>
				<p>As you are aware, our workshop-based $1,000 scholarship was not offered due to loss of private funding. However, we did have remaining scholarship program funding from a previous Performance Based Scholarship (PBS) program to offer at a regional level. We are awarding a total of 47 Performance Based Scholarships statewide. Each region in the state is offered at least a minimum of two scholarships per region.</p>
				
				<h5>Scholarships are performance-based</h5>
				<p>Scholarships will be there for students as they perform at a qualifying college starting this Fall. As students maintain at least 6.0 units and a 2.0 GPA they will receive periodic payments.  Find out more about payments in the FAQs below.</p>
				
				<p>We give you the opportunity to award scholarships because we have received feedback that it is a pleasant and rewarding experience.</p>
				
				<p>The Materials section of this page includes templates used to award scholarships and inform recipients of the things they must do to receive payment. They&lsquo;re important. Please contact us if you have any questions or need assistance awarding your scholarships.</p>
			</section>
			
			<section id="scholarship-materials">
				<h3>Scholarship Materials</h3>
				<div class="row-fluid">
					<div class="span12">
						<ul class="nav nav-pills nav-stacked">
							<li><a href="http://www.calgrants.org/documents/2015_Cash_for_College_Scholarship_Award_Letter_Template.doc" target="_blank"><img src="common/icons/word_32.png" alt="" width="32" height="32" border="0" style="margin-right: 8px;" />2015 Cash for College Scholarship Award Letter Template</a></li>
							<li><a href="http://www.calgrants.org/documents/2015_Cash_for_College_Scholarship_FAQs.pdf" target="_blank"><img src="common/icons/pdf_32.png" alt="" width="32" height="32" border="0" style="margin-right: 8px;" />2015 Cash for College Scholarship FAQs</a></li>
						</ul>
						<!--- <p>Scholarship materials will be available after scholarships are awarded</p> --->
					
						<!--- <div class="alert alert-info notFound">Scholarship materials will be available after scholarships are awarded</div> --->
						
						<!--- <cfif ListFind("1,2,3,5,12", request.authUser.regionID) gt 0>
							<h4>Performance Based Scholarships</h4>
							<ul class="nav nav-pills nav-stacked">
								<li><a href="http://www.calgrants.org/documents/2013_California_Cash_for_College_Award_Letter_Template_PBS.docx" target="_blank"><img src="common/icons/word_32.png" alt="" width="32" height="32" border="0" style="margin-right: 8px;" />2013 PBS Sustainability Scholarship Award Letter</a></li>
								<li><a href="http://www.calgrants.org/documents/2013_Cash_for_College_Scholarship_FAQs_PBS.pdf" target="_blank"><img src="common/icons/pdf_32.png" alt="" width="32" height="32" border="0" style="margin-right: 8px;" />2013 PBS Sustainability Scholarship FAQs</a></li>
							</ul>
							<h4>Cash for College Scholarships</h4>
						</cfif> ---> 
						
						<!--- <ul class="nav nav-pills nav-stacked">
							<li><a href="http://www.calgrants.org/documents/2014_Cash_for_College_Scholarship_Award_Letter_Template.doc" target="_blank"><img src="common/icons/word_32.png" alt="" width="32" height="32" border="0" style="margin-right: 8px;" />2014 Cash for College Scholarship Award Letter Template</a></li>
							<li><a href="http://www.calgrants.org/documents/2014_Cash_for_College_Scholarship_FAQs.pdf" target="_blank"><img src="common/icons/pdf_32.png" alt="" width="32" height="32" border="0" style="margin-right: 8px;" />2014 Cash for College Scholarship FAQs</a></li>
							<li><a href="http://event.reg.meeting-stream.com/sl/integration/StreamLine.aspx?a=3XLh23o84BV6108f7Sft&s=9d81afac56d1420eaaf2534a14af2aac" target="_blank"><img src="common/icons/url_32.png" alt="" width="32" height="32" border="0" style="margin-right: 8px;" />2014 How to Claim your Cash for College Scholarship Video</a></li>
							<li><a href="http://www.calgrants.org/documents/2014_Cash_for_College_Scholarship_Orientation.pdf" target="_blank"><img src="common/icons/pdf_32.png" alt="" width="32" height="32" border="0" style="margin-right: 8px;" />2014 Cash for College Scholarship Orientation</a></li>
							<li><a href="http://www.calgrants.org/applications/scholarships" target="_blank"><img src="common/icons/url_32.png" alt="" width="32" height="32" border="0" style="margin-right: 8px;" />Scholarship Claim Site</a></li>
							<!--- <li><a href="#" onclick="alert('Certificates are being generated and will be ready shortly'); return false;" target="_blank"><img src="common/icons/pdf_32.png" alt="" width="32" height="32" border="0" style="margin-right: 8px;" />2014 Cash for College Scholarship Certificate</a></li> --->
						</ul> --->

					</div>
				</div>
			</section>
			
			<section id="scholarships">
				<h3>Scholarship Recipients</h3>

				<cfscript>
					base = new assets.calgrants.com.Base();
					scholarshipGateway = new assets.calgrants.com.gateway.ScholarshipGateway();
					scholarships = scholarshipGateway.query(organizationIDs = request.authUser.organizationID, Cohort = 7);
					/*if (ListFind("1,2,3,5,12", request.authUser.regionID) gt 0) {
						pbsScholarships = scholarshipGateway.query(organizationIDs = request.authUser.organizationID, Cohort = 5, Scholarship_Type = "Performance Based Scholarship");
					}*/
				</cfscript>
				
				<!--- <cfset workshopIDs = ValueList(scholarships.Workshop_ID)>
				<cfif ListFind("1,2,3,5,12", request.authUser.regionID) gt 0 and pbsScholarships.RecordCount gt 0>
					<cfloop query="pbsScholarships">
						<cfif ListFind(workshopIDs, Workshop_ID) eq 0>
							<cfset workshopIDs = ListAppend(workshopIDs, Workshop_ID)>
						</cfif>
					</cfloop>
				</cfif> --->
				
				<!--- <cfset studentIDs = ValueList(scholarships.Student_ID)>
				<cfif ListFind("1,2,3,5,12", request.authUser.regionID) gt 0 and pbsScholarships.RecordCount gt 0>
					<cfloop query="pbsScholarships">
						<cfif ListFind(studentIDs, Student_ID) eq 0>
							<cfset studentIDs = ListAppend(studentIDs, Student_ID)>
						</cfif>
					</cfloop>
				</cfif> --->
				
				<!--- <cfquery name="GetRejections" datasource="#base.getDatasource()#">
					select *
					from Workshops_With_Rejections_2013
					where Workshop_ID in (<cfqueryparam list="yes" value="#workshopIDs#">)
				</cfquery>
				
				<cfquery name="GetScholarshipDupes" datasource="#base.getDatasource()#">
					select distinct Student_ID
					from scholarship_dupes_2013
					where Student_ID in (<cfqueryparam list="yes" value="#studentIDs#">)
				</cfquery>

				<cfif GetRejections.RecordCount eq 2>
					<p>Thanks to quick feedback from an organizer, we looked into inconsistencies with our scholarship rosters. We have reselected recipients for two of your scholarships, and have updated your account with new recipient information below for you. You are now free to notify your scholarship recipients. If you have questions, please let us know.</p>
				<cfelseif GetRejections.RecordCount eq 1>
					<p>Thanks to quick feedback from an organizer, we looked into inconsistencies with our scholarship rosters. We reselected a new scholarship recipient for your site and have updated your account with new recipient information below. You are now free to notify your scholarship recipients. If you have questions, please let us know, thank you.</p>
				</cfif>
				<cfif GetScholarshipDupes.RecordCount gt 0>
					<p>The list we published in your account Friday afternoon contained a student who was awarded for both types of scholarships. A student cannot receive more than one scholarship. The student who was previously listed as having received both scholarships, was kept on the list to receive the $2,000 scholarship. We reselected another student for the $1,000 scholarship. Please let us know if you have any questions, thank you.</p>
				</cfif> --->
				
				<cfif scholarships.RecordCount gt 0>
					<!--- <cfoutput>
						<p>
							<a href="?action=export&collection=scholarships" class="btn btn-success" target="_new">Export&nbsp;Scholarships</a>
							<cfif scholarships.RecordCount eq 1>
								<a href="/assets/calgrants/ui/printable/scholarships/scholarshipCertificate.cfm?Organization_ID=#request.authUser.organizationID#" class="btn btn-success" target="_new">Download&nbsp;Certificate</a>
							<cfelseif scholarships.RecordCount gt 1>
								<a href="/assets/calgrants/ui/printable/scholarships/scholarshipCertificate.cfm?Organization_ID=#request.authUser.organizationID#" class="btn btn-success" target="_new">Download&nbsp;Certificates</a>
							</cfif>
						</p>
					</cfoutput> --->
				
					<!--- <h4>Cash for College Scholarships</h4> --->

					<table id="scholarshipsTable" class="table table-hover table-bordered">
						<thead>
							<tr>
								<th>Name</th>
								<th>Claim ID</th>
								<th>E-mail</th>
								<th>Phone</th>
								<th>Claim Status</th>
								<!--- <th></th> --->
							</tr>
						</thead>
						<tbody>
							<cfoutput query="scholarships">
								<tr>
									<cfif IsDate(Claim_Date)>
										<td><a href="?view=scholarship&Scholarship_ID=#Scholarship_ID#">#First_Name# #Last_Name#</a></td>
										<td>#Claim_ID#</td>
										<td>#Email#</td>
										<td nowrap="nowrap">#Phone1#</td>
									<cfelse>
										<td>#First_Name# #Last_Name#</td>
										<td>#Claim_ID#</td>
										<td>#Student_Email#</td>
										<td nowrap="nowrap">#Student_Phone1#</td>
									</cfif>
									<!--- <td>#Enrollment_Date#</td> --->
									<td>
										<cfif ListFirst(Claim_Status, ";") eq "Claimed">
											<abbr title="#DateFormat(Claim_Date, 'm/d/yyyy')#">#ListFirst(Claim_Status, ";")#</abbr>
										<cfelseif ListFirst(Claim_Status, ";") eq "Partial">
											<abbr title="#Replace(ListLast(Claim_Status, ';'), ',', ', ', 'all')#">#ListFirst(Claim_Status, ";")#</abbr>
										<cfelse>
											#ListFirst(Claim_Status, ";")#
										</cfif>
									</td>
									<!--- <td><a href="/assets/calgrants/ui/printable/scholarships/scholarshipCertificate.cfm?Scholarship_ID=#Scholarship_ID#" target="_blank" class="btn btn-success">Certificate</a></td> --->
									<!--- <td><cfif Len(GDS_High_School) gt 4>#base.TitleCase(GDS_High_School)#, #base.TitleCase(GDS_High_School_City)#<cfelse>#Q8#</cfif></td>
									<td>$1,000</td> --->
									<!--- <td>
										<!--- <div class="btn-group">
											<a href="##" class="btn btn-success btn-block dropdown-toggle" data-toggle="dropdown">
												Select&nbsp;&nbsp;&nbsp;<span class="caret"></span>
											</a>
											<ul class="dropdown-menu">
												<li><a href="?view=followUpRequests&Workshop_ID=#Workshop_ID#">Manage Follow Up Requests</a></li>
												<li><a href="?action=export&collection=followUps&Workshop_ID=#Workshop_ID#" target="_blank">Export Follow Up Requests</a></li>
											</ul>
										</div> --->
									</td> --->
								</tr>
							</cfoutput>
						</tbody>
					</table>
					
				<cfelse>

					<div class="alert alert-info notFound">No scholarships were awarded to attendees of your workshops</div>
					<p><a href="http://www.calgrants.org/documents/2015_Regional_Scholarship_Locations.pdf" target="_new">Download a list</a> of locations that were awarded scholarships.</p>

				</cfif>
				
				<!--- <cfif ListFind("1,2,3,5,12", request.authUser.regionID) gt 0 and pbsScholarships.RecordCount gt 0>
				
					<h4>Performance Based Scholarships</h4>
					
					<table id="pbsScholarshipsTable" class="table table-hover table-bordered">
						<thead>
							<tr>
								<th>Name</th>
								<th>Claim ID</th>
								<th>E-mail</th>
								<th>Phone</th>
								<!--- <th>Enrollment Date</th> --->
								<th>Claim Status</th>
								<!--- <th>High School</th>
								<th>Claim Date</th>
								<th>Amount</th> --->
								<!--- <th class="action"></th> --->
							</tr>
						</thead>
						<tbody>
							<cfoutput query="pbsScholarships">
								<tr>
									<td>
										<cfif IsDate(Claim_Date)>
											<a href="?view=scholarship&Scholarship_ID=#Scholarship_ID#">#First_Name# #Last_Name#</a>
										<cfelseif Len(GDS_Last_Name) gt 0>
											<a href="?view=scholarship&Scholarship_ID=#Scholarship_ID#">#base.TitleCase(GDS_First_Name)# #base.TitleCase(GDS_Last_Name)#</a>
										<cfelse>
											<a href="?view=scholarship&Scholarship_ID=#Scholarship_ID#">#base.TitleCase(Student_First_Name)# #base.TitleCase(Student_Last_Name)#</a>
										</cfif>
									</td>
									<td>#Claim_ID#</td>
									<td>#Student_Email#</td>
									<td>#Student_Phone1#</td>
									<!--- <td>#Enrollment_Date#</td> --->
									<td>
										<cfif ListFirst(Claim_Status, ";") eq "Claimed">
											<abbr title="#DateFormat(Claim_Date, 'm/d/yyyy')#">#ListFirst(Claim_Status, ";")#</abbr>
										<cfelseif ListFirst(Claim_Status, ";") eq "Partial">
											<abbr title="#Replace(ListLast(Claim_Status, ';'), ',', ', ', 'all')#">#ListFirst(Claim_Status, ";")#</abbr>
										<cfelse>
											#ListFirst(Claim_Status, ";")#
										</cfif>
									</td>
									<!--- <td><cfif Len(GDS_High_School) gt 4>#base.TitleCase(GDS_High_School)#, #base.TitleCase(GDS_High_School_City)#<cfelse>#Q8#</cfif></td>
									<td>$2,000</td>
									<td>
										<!--- <div class="btn-group">
											<a href="##" class="btn btn-success btn-block dropdown-toggle" data-toggle="dropdown">
												Select&nbsp;&nbsp;&nbsp;<span class="caret"></span>
											</a>
											<ul class="dropdown-menu">
												<li><a href="?view=followUpRequests&Workshop_ID=#Workshop_ID#">Manage Follow Up Requests</a></li>
												<li><a href="?action=export&collection=followUps&Workshop_ID=#Workshop_ID#" target="_blank">Export Follow Up Requests</a></li>
											</ul>
										</div> --->
									</td> --->
								</tr>
							</cfoutput>
						</tbody>
					</table>

				</cfif> --->
			</section>
			
			<section id="whats-next">
				<h3>What&rsquo;s Next</h3>
				<h4>How Did We Do</h4>
				<p>The How Did We Do reports present some of our most important performance indicators in a sharable infographic format.</p>
				<p><a href="?view=howDidWeDo" class="btn btn-success">Do&nbsp;It&nbsp;Now</a></p>
			</section>

		</div>
	</div>
</cfif>